#!usr/bin/env python  
# -*- coding:utf-8 _*-
""" 
@author:robot
@file: mysql01.py 
@version:
@time: 2022/01/17 
"""
from TapClientCaseData.ColumnGenerateData.dynamic.base.base00_dynamic import ORACLE02_TYPE
from TapClientCaseData.ColumnGenerateData.dynamic.base.base00_dynamic import generate_columns_data

ORACLE02_COLUMNS = ORACLE02_TYPE.get('COLUMNS')

BASE = ORACLE02_COLUMNS.get('BASE')
PK = BASE.get('PK').lower()
NO_PK = BASE.get('NO PK').lower()

# ****CHARACTER****
CHARACTER = ORACLE02_COLUMNS.get('CHARACTER')

# ****NUMERIC****
NUMERIC = ORACLE02_COLUMNS.get('NUMERIC')

# ****DATE****
_DATE = ORACLE02_COLUMNS.get('DATE')

# ****LOB****
LOB = ORACLE02_COLUMNS.get('LOB')

# ****RAW****
_RAW = ORACLE02_COLUMNS.get('RAW')

# --CHARACTER--
CHAR = CHARACTER.get('CHAR').get('CREATE')
VARCHAR2 = CHARACTER.get('VARCHAR2').get('CREATE')
NCHAR = CHARACTER.get('NCHAR').get('CREATE')
NVARCHAR2 = CHARACTER.get('NVARCHAR2').get('CREATE')

# --NUMERIC--
NUMBER = NUMERIC.get('NUMBER').get('CREATE')
FLOAT = NUMERIC.get('FLOAT').get('CREATE')
BINARY_FLOAT = NUMERIC.get('BINARY_FLOAT').get('CREATE')
BINARY_DOUBLE = NUMERIC.get('BINARY_DOUBLE').get('CREATE')

# --DATE--
DATE = _DATE.get('DATE').get('CREATE')
TIMESTAMP = _DATE.get('TIMESTAMP').get('CREATE')
TIMESTAMP_WITH_TIME_ZONE = _DATE.get('TIMESTAMP_WITH_TIME_ZONE').get('CREATE')
TIMESTAMP_WITH_LOCAL_TIME_ZONE = _DATE.get('TIMESTAMP_WITH_LOCAL_TIME_ZONE').get('CREATE')
INTERVAL_YEAR_TO_MONTH = _DATE.get('INTERVAL_YEAR_TO_MONTH').get('CREATE')
INTERVAL_DAY_TO_SECOND = _DATE.get('INTERVAL_DAY_TO_SECOND').get('CREATE')

# --LOB--
LONG = LOB.get('LONG').get('CREATE')
BLOB = LOB.get('BLOB').get('CREATE')
CLOB = LOB.get('CLOB').get('CREATE')
NCLOB = LOB.get('NCLOB').get('CREATE')
BFILE = LOB.get('BFILE').get('CREATE')

# --RAW--
RAW = _RAW.get('RAW').get('CREATE')
LONG_RAW = _RAW.get('LONG_RAW').get('CREATE')
